﻿if exists (select * from dbo.sysobjects where name = 'sp_Departments_Insert')	drop procedure [dbo].[sp_Departments_Insert]Go CREATE PROCEDURE dbo.sp_Departments_Insert	@dpCode		nvarchar(50),	@dpName		nvarchar(150),	@dpLevel		nvarchar(100),	@dpOrd		intAS	INSERT INTO [Departments]([dpCode], [dpName], [dpLevel], [dpOrd])	VALUES(@dpCode, @dpName, @dpLevel, @dpOrd)Go 